Back to Main Menu

Advanced Search - Pivot Tables

After running an advanced search, click on the Pivot Table button as shown below:

The following screen will appear:

Click Show Column Customization.

 

All fields selected in the Advanced Asset Search appear in Pivot Grid Field List:

Drag the required fields into the Pivot report area. Users can view and group the data as required:

To add a new field to the Pivot report click an the Add Expression Field.The following screen will appear:

To add an expression click on the '...' button.The following screen will appear:

The expression editor calculator is a powerful tool that facilitates numerous calculations to be carried out on selected fields.

Using Functions and Fields in the Expression Editor, enter the required formula and click OK.

The newly added field appears in the report as shown above. Users can then export the data: